<%-- 
    Document   : jobid_apply_details
    Created on : Apr 10, 2012, 10:59:25 AM
    Author     : project
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<%@page import="java.sql.*"%>
<%@page import="jobportal.Dbconn" %>
<%@include file="header.jsp" %>
<%try{
   Connection con=Dbconn.getConn();
   String jobid="";
   jobid=request.getParameter("jobid");
   Statement st=con.createStatement();
   String   sql="select student.username,student.name,job_applied.jobid,jobtitle,clgname,walkindate,dob,hallticketstatus from jobs,college,student,job_applied where job_applied.jobid='"+jobid+"' and job_applied.jobid=jobs.jobid and job_applied.username=student.username and student.clgid=college.clgid and hallticketstatus!='verified' and walkindate>=curdate()";
   ResultSet rs=st.executeQuery(sql);
%>


<table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td align="left" valign="top">

            <span class='messagesred' style="text-align:center">
            </span>

            <table width="100%" border="0" cellspacing="0" >
                <tr>
                    <td width="100%" align="left" valign="top"><span class="mainheading_emp" style="margin-bottom:10px;"> Verify Hallticket Status</span>
</td>
                </tr>
                <tr>
                    <td height="10" align="left" valign="top" class="normal"></td>
                </tr>
                <tr>
                    <td height="26" align="left" valign="top" class="normal">
                        <table width="100%" border="0" cellspacing="2"  class="tbl_bdr">
                            <tr class="sde_mnu_hdr_blue">
                                <td width="3%" align="left" valign="middle"><img style="margin-top:-5px; margin-left:-5px;" src="../images/top_left.gif";/></td>
                              <td width="15%" align="left" valign="middle" class="subjeading"> Name</td>
                              <td width="10%" align="left" valign="middle" class="subjeading">Job Title</td>
                              <td width="11%" align="left" valign="middle" class="subjeading">Walkindate</td>
                              <td width="12%" align="left" valign="middle" class="subjeading">College </td>
                              <td width="11%" align="left" valign="middle" class="subjeading">Birthdate</td>
                              <td width="11%" align="left" valign="middle" class="subjeading">HallTicket </td>
                              <td width="27%" align="left" valign="middle" class="subjeading">Action</td>
                          </tr>

          <%while(rs.next()){ %>
                            <tr class="greybg">
                                <td align="center" valign="top">&nbsp;</td>
                                <td align="left" valign="top" class="link"><a href="view_posted_jobs_emp.jsp?jobid=<%=rs.getString("jobid")%>" title="View Job Details"><%= rs.getString("name") %></a></td>
                                <td align="left" valign="top"><%= rs.getString("jobtitle")%></td>
                                <td align="left" valign="top"><%=rs.getString("walkindate")%></td>
                                <td align="left" valign="top"><a href="job_delete_code.jsp?memid=62" onclick="javascript: return confirm('All the  information related to this Job Postings will be deleted.\n\nDo you really want to delete the Job Posting?');"></a></span><%=rs.getString("clgname")%></td>
                              <td align="left" valign="top"><a href="job_delete_code.jsp?memid=62"></a>              <font color='#6699FF'><%= rs.getString("dob") %></font>          </td>
                                <td align="left" valign="middle"><font color='green'><%=rs.getString("hallticketstatus")%></font></td>
                          <td align="left" valign="middle">

                                    <a href="jobid_apply_details.jsp?jobid=<%=rs.getString("jobid")%>" title="View Student Profile"><input id="submit" name="submit" type="submit" value="View" class="button2" style="width:50px; height:20px;"></a>
                                <a href="StatusVerify?jobid=<%=jobid%>&username=<%=rs.getString("username")%>&status=Verified" title="Verify status"><input id="submit1" name="submit1" type="submit" value="Verify" class="button2" style="width:50px; height:20px;">
                                </a><a href="StatusVerify?jobid=<%=jobid%>&username=<%=rs.getString("username")%>&status=Not Verified" title="Status Not verified "> 
                                <input id="submit2" name="submit2" type="submit" value="Disprove" class="button2" style="width:60px; height:20px;"></a><a href="StatusVerify?jobid=<%=jobid%>&username=<%=rs.getString("username")%>&status=not verified" title=""></a></td>
                          </tr>
<%}%>
                  </table></td>
                </tr>
            </table></td>
    </tr>
</table>
<%}catch(Exception e){
out.println("<font color=\"black\">"+e+"</font>");
}%>
<%@include file="footer.jsp" %>